Collection of Overdue Invoices, EMD’s and Security Deposits from Government Procurement Bodies & Trade Channel for Pharmaceutical Business
Pharmaceutical companies face pressure to cut costs and lower prices, while struggling with decreased profitability. They are facing healthcare reforms that affect drug trials, sales, pricing, and manufacturing. Improving cash flow management can ease these pressures and support innovation, leading to sustained profits.
At a Pharma CEOs virtual round table on the opportunities and challenges of post COVID-19 pandemic, organized by the Bangalore Chamber of Industry and Commerce (BCIC) and KDPMA, it was noted that while the challenges for the large pharma companies are scaling up of capital investment, pricing and productivity, the MSMEs have their own challenges of cash flow management, costs for compliance, manufacturing and product promotion besides skill availability.
1. How GGA can assist with “Faster” Cash flow Collections – especially Government Dues/Procurement Bodies etc.
A MNC Pharmaceutical client had a problem with the collections of their Overdue Invoices, EMD’s and Security Deposits – the debtors were of the following nature:
35% value of our clients’ debtors were overdue by more than 180 days, the client approached GGA for assistance to:
To commence the assignment, GGA requested for the detailed debtors ageing and used an analytical approach to identify the delinquent and delayed paying customers, GGA categorized the customers into 4 categories:
Category | Description |
A category | Customers buys regularly and pays on time |
B category | Customers buys regularly, but pays erratically and has overdue |
across multiple ageing buckets | |
C category | Customer has not made a purchase in the last 3 months, but still |
owes money to our client | |
D category | Customers where legal cases had already been filed – sec 138 etc. |
Basis the categorization – GGA made a collections strategy to address the overdue issue and focus on collections from the Government.
2. Problems identified as to why did the customers not pay on time – Government Customers
For Government customers, documentation is of prime importance and GGA validates the information, documents and data available prior to visiting the customers.
While visiting the customers for the collections activities we identified the following reasons, why customers do not pay as per the agreed credit period.
3. Solutions Provided for Government Collections
4. Problems identified as to why did the customers not pay on time – Dealers and Distributors
No one pays without multiple reminders, and the person who follows up first, gets paid on priority
The dealers and distributors never use their own capital / funds and pay after they have recovered their own dues from the market. Therefore, if their cashflow faces a problem, they will not pay their creditors on time.
While visiting the customers for the collections activities we identified the following reasons, why customers do not pay, as per the agreed credit period
5. Solutions Provided for Dealer and Distributor Collections
6. End results of the assignment
GGA submits detailed performance dashboards on a monthly basis, please see the dashboard as below for
Performance Dashboard – Government Collections
Performance Dashboardfor Follow Up with State Procurement Bodies-May 15,2022 | |||||
Rs in lacs | Govt 1 | Govt 2 | Govt 3 | Total | Details |
Total O/S Shared with GGA | 651.8 | 509.82 | 111.04 | 1272.62 | |
Govt 1 Direct | |||||
1. Credit of INR 15.77 Lacs received on 29th Nov'21 ( LD amount INR 3,442/-); 2. Credit of INR 49.83 Lacs received on 2nd Dec'21 (LD amount INR 9,694/-) | |||||
3. Credit of INR 48.34 Lacs received on 2nd Feb'22 (LD amount INR 191,031/-); 4. Credit of INR 65.43 Lacs received on 22nd Mar'22 (LD amount INR 930,078/-) Govt 2 - Govt 1 | |||||
1. Credit of INR 155.24 lacs received on 24th Dec'21 (LD amount INR 4.12 L); 2. Credit of INR 168.75 Lacs received on 28th Mar'22 (LD amount 11 lacs) | |||||
Paid | 182.8 | 330.18 | 513.02 | ||
Paid (Govt 2) | 20.86 | 20.86 | Credit of INR 20.86 Lacs received on 3rd Mar'22 | ||
Paid (Govt 3) | 17.52 | 17.52 | Credit against invoices for INR 19.13 lacs received | ||
LD Deducted | 11.34 | 15.42 | 1.61 | 28.37 | LD deducted by 1. Govt 1 - INR 13,136 + INR 191,031 + INR 930,078 = INR |
Short Supply / Expiry | 7.78 | 5.13 | 12.91 | Short expiry - 1900 units (as per contract expiry or min 9 months required at time | |
of delivery) no exception | |||||
Refused - Material returned as expired | 6.51 | 6.51 | Recommend to remove from AR list | ||
Refused - Material not Received | 0.42 | 1.68 | 2.1 | Recommend to remove from AR list | |
2015 cases - part payment cases | 3.12 | 3.12 | Recommend to remove from AR list | ||
Old short payment appearing as O/S | 56.37 | 56.37 | INR 56.37 is towards deductions and not collectable - reconciliation shared with | ||
Client (LD) | |||||
Govt 2 submitted the bills to Govt 1 | 16.59 | 16.59 | Govt 1 removed these invoices due to some internal queries; Govt 2 will re-submit | ||
these bills along with 100 lacs bills | |||||
Fresh Cases - CRCs handed over to Mr XYZ ; Bills submitted to Govt 2 on 28th April'22 and Govt 2 has also processed the bills on same day and payment | |||||
Fresh Cases added in Apr'22 (Govt 2) | 16.62 | 16.62 | will be released as per payment terms (45 days) | ||
Bill submitted to Govt 2 on 24th Dec'21 of INR 100.69 Lacs; Govt 2 raised queries now resolved - current status as below | |||||
*Short Expiry of 1900 kits - INR 7,74,139/-; * Short supply of 800 kits 2 locations of INR 3,75,497/- (Rs 38K penalty) - Rs 8.12 lacs will be deducted | |||||
Invoices submitted to Govt 2 on 17th May 2022 & Govt 2 will submit the invoice | |||||
Bills under query with Client | 100.69 | 100.69 | to Govt 1 by 27th May'22 | ||
Bills pending for submission (CRC received) | *Invoices of INR 11.14 lac has been uploaded on Aushadhi portal against PO # 63; Hard copy will be submitted by 9th May'22; Govt 3 refuse to accept Invoice for 3rd Trache of State 2 Location of INR 1.33 lacs due to contract obligation of 50% | ||||
supply | |||||
*Invoice of INR 12.76 lac against PO# is yet to be uploaded - unable to load | |||||
23.9 | 23.9 | in portal GGA To raise with Govt 3 IT TEAM | |||
Govt 1 - New Data Apr 22 | 368.4 | 368.43 | Fresh Cases - CRC follow-up in progress - CRC Received / In Transit - INR 354 lacs; | ||
CRC Follow-up WIP - INR 14.4 Lacs ( Inv of Pithoragarh of INR | |||||
Govt 1 - New Data May 22 | 85.61 | 85.61 | Tranche 4 invoices added in May-22 - CRC Received / In Transit -Rs 32 lac; CRC Pending- Rs 53.60 Lacs |
Performance Dashboard – EMD Collections
BG EMD - Status update May 15, 2022 | ||||||
BG Count | Pending % | EMD/SD | Pending % | Total | Pending % | |
Rs in Lacs | BG Count | BG Value | EMD/SD | EMD/SD Value | Total | Total Value |
Cases Allotted to GGA | 56 | 709.43 | 65 | 605.52 | 121 | 1314.95 |
Out of Scope Work not done | 0 | 0 | 13 | 176.82 | 13 | 176.82 |
Effective cases allotted to GGA | 56 | 709.43 | 52 | 428.7 | 108 | 1138.14 |
Collected | 44 | 641.92 | 32 | 333.1 | 76 | 975.02 |
Details of past payment collected and confirmed - Now Knocked off post sharing of details by GGA | 4 | 15.91 | 4 | 15.91 | ||
Balance | 12 | 67.52 | 16 | 79.69 | 28 | 147.21 |
Forecast | 0 | 0 | 3 | 35 | 3 | 35 |
Under GGA follow-up | 5 | 22.62 | 3 | 18.17 | 8 | 40.79 |
Release letters/ Indemnity Bond to be issued | 2 | 7.53 | 2 | 7.53 | ||
Balance Cases - Low Probability of obtaining additional Inputs | 7 | 44.9 | 8 | 18.99 | 15 | 63.89 |
Incomplete / Short Supply - Risk | 3 | 42.79 | 1 | 10.75 | 4 | 53.54 |
Contact details awaited | 3 | 0.24 | 2 | 4 | 5 | 4.24 |
BG submission proof required/ EMD Details & Documents | 1 | 1.86 | 4 | 4.23 | 5 | 6.09 |
Performance Dashboard – Dealers & Distributors
Category | In Co. Scope | In GGA Scope of Collection | |||||||
0 to 180 | Nos | % | Total | 180 to 365 | 1 to 2 Years | 2 to 3 Years | 3 to 4 Y | > 4 Y | |
Data given at the commencement of the assignment | 218,009,625 | 181 | 100% | 116,763,993 | 13,956,016 | 19,594,894 | 22,762,733 | 23,439,711 | 37,010,639 |
Amount collected in 6 months | 79 | 36% | 41,716,115 | 7,955,784 | 10,642,333 | 9,442,444 | 8,442,223 | 5,233,331 | |
Balance to be collected | 218,009,625 | 102 | 64% | 75,047,878 | 6,000,232 | 8,952,561 | 13,320,289 | 14,997,488 | 31,777,308 |
Risks of non payments / issued raised by customers | - | 36 | 38% | 43,832,487 | 901,700 | 2,544,299 | 4,665,634 | 11,038,735 | 24,682,119 |
Alternate KYC Required / customer absconded | 9 | 6,753,803 | 901,700 | 923,333 | 435,555 | 1,006,651 | 3,486,564 | ||
Refuse to Pay due to packaging damage / owner died etc | 10 | 13,435,269 | 943,222 | 1,543,232 | 1,765,454 | 9,183,361 | |||
Material Expired | 17 | 23,643,415 | 677,744 | 2,686,847 | 8,266,630 | 12,012,194 | |||
Balance collectable | 218,009,625 | 66 | 27% | 31,215,391 | 5,098,532 | 6,408,262 | 8,654,654 | 3,958,753 | 7,095,189 |
Forecasts for future collections | 31 | 8% | 9,509,420 | 3,800,212 | 1,908,946 | 1,754,233 | 895,347 | 1,150,682 | |
Suggested for legal cases - ability to pay but no intent to pay | 5 | 3% | 3,321,010 | 211,333 | 848,743 | 537,373 | 1,723,561 | ||
Under detailed follow up - discussions awaited | 30 | 16% | 18,384,961 | 1,298,320 | 4,287,983 | 6,051,678 | 2,526,033 | 4,220,947 | |
The reasons for risks and non-payments, were analyzed, so that future risks and non- payments could be avoided.
7. Time Frame for conducting the assignment
GGA set up a time frame for conducting the assignment, we received assurances from the management for 2 hours per month to discuss the performance dashboard
Time frame to collect the old outstandings | ||
Month | Normal Process Follow Ups for Collection of Overdue Debtors | Focus |
Collection of data / contact details of customers / discussions with the sales team | Continuous follow up by the GGA team till the overdue invoices are collected | |
Circulation of data to the customers / identifying the right person to speak with | ||
1 - 30 days | Customer visits by GGA team - telecalling and follow up commenced | |
Payments start coming in. Customers looking into their records -especially for older years | ||
2nd - 3rd month | Payments momentum builds up, Customers respond - already issued, disputes will pay | |
4th month | Submission of additional information to customers, continuous follow up | |
5th - 6th month | Customers start paying for older years, push for difficult collections, legal cases etc |
8. Challenges at the time of commencement of the assignment
No assignment starts smoothly due to apprehensions regarding changes and new processes and GGA faced certain challenges prior to the signing of the agreement and for about 15 days post commencement of the assignment.
The challenge was from the sales team, as they were resisting change, as well as a third party talking / visiting their customers for collections, further they were worried about how we would be treating their customers and the feedback the customers might give about the sales process etc.
The resistance from the sales team disappeared, after 15 days due to GGA’s project management approach:
9. How did the customers view GGA as a third party – Positively OR Negatively
We are glad to say that there was no negative fallout and customers accepted GGA’s follow up processes and approach for collections
GGA’s team consists of multilingual telecallers and Regional Feet on Street Resources – Pan India. The resources are all on the payroll of GGA and highly trained in “customer management and collections management” – they are all B2B experts.
When GGA’s team meets the dealers and distributors – after prior appointment, they take care of the following communication protocols:
There are times when the dealers / distributor does not want to talk to us, in that case we take their permission to take the relevant sales person on a conference call, so that the bonafides can be reinforced and discussions can move ahead.
10. About GGA
GGA India Private Limited (GGA) is a focused “Business to Business” Account Receivables Management (“ARM”) Service Provider. GGA concentrates exclusively on designing, developing and implementing customized B2B debtor collections solutions for its clients.
Founded in 2002, GGA works with B2B organizations to collect from both concurrent and legacy debtors.
For any information or clarification, please contact
Gaurav Gupta – CEO Chartered Accountant
+ 91 98111 63422,
Want to Discuss Your Outsourcing Needs?